<?php

namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use DB;

class Comcheckstep extends Model
{
    //
    protected $table = 'comcheckstep';

    public function getfiretype($companyId)
    {
    	$checkstep = DB::select("SELECT step.stepStatus,step.typeStatus FROM comcheckstep step LEFT JOIN comcheck on comcheck.id = step.checkId WHERE comcheck.companyId = $companyId");
        return $checkstep;
    }
}
